Hiding an inquiry column

If your security settings allow you to change inquiries, you can change an inquiry so that it hides a column all the time or hides a column only when it contains no data.

For example:

  • You might hide a column all the time if the sole purpose of the column is to be referenced by another column or a formula. The information in the column itself is not important to you.

For example, you use an order key to sort an inquiry. You don't want the column to appear.

  • You might hide a column when it contains no data if you are using an inquiry more as an information source, rather than a formal report. You want to see information only if it is available.

For example, you add the Written off column to the Project inquiry, but want the column to appear only if there is a written-off amount.

To hide an inquiry column

  1. From the > Reports > Standard Inquiries or Custom Inquiries menu, select the inquiry you want.
  2. Right-click the heading of the column you want to hide, and click Properties.
  3. On the General tab, from the Visibility field, select:
  • Hide If No Data to hide the column if it contains no data.
  • Always Hide to hide the column all the time.
  1. Click OK.
  2. The button appears in the Inquiry toolbar. If you click this button, all hidden columns appear in the inquiry, with their headings dimmed to indicate that the columns are normally hidden.
Note: If you preview, print, or export an inquiry with hidden columns shown, then those columns also appear in the previewed, printed, or exported file.
  1. The button appears in the Inquiry toolbar; click this button to hide the columns again.
Note: If you preview, print, or export an inquiry with hidden columns hidden, then those columns do not appear in the previewed, printed, or exported file.